import matplotlib.pyplot as plt
import pandas as pd
df = pd.read_excel('营销和产品销量表.xlsx', index_col=0)
plt.rcParams['font.sans-serif'] = 'SimHei'
plt.rcParams['figure.figsize'] = (8, 5)
x = df['展现量']
y1 = df['点击量']
plt.subplot(2, 2, 1)
plt.scatter(x, y1)
plt.legend(('展现量与点击量',), loc='lower right')
plt.show()